package com.woniuxy.driverschool.mapper;

import com.woniuxy.driverschool.entity.StudyTime;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
 * @author: xyq
 * @version: 1.0.0
 * @create: 2021/9/28 16:55
 * @description: TODO
 */
public interface StudyTimeMapper {
    //增添学员学时信息
    void addStudyTime(StudyTime studyTime);
    //删除学员学时信息
    void removeStudyTime(int stid);
    //修改学员学时信息
    void updateStudyTime(int oneElapsedTime, int twoElapsedTime, int threeElapsedTime, int fourElapsedTime,String student,int stid);
    //通过id查询学员学时
    StudyTime selectStudyTimeByStid(int stid);
    //分页查询学员学时
    List<StudyTime> selectAllStudyTimesByPage(@Param("studyTime") StudyTime studyTime,@Param("pageIndex") Integer pageIndex, @Param("pageSize") Integer pageSize,
                                              @Param("startTime") Date startTime, @Param("endTime") Date endTime);
    //学员学时总条数
    int selectCountStudyTimesByPage(@Param("studyTime") StudyTime studyTime, @Param("startTime") Date startTime,@Param("endTime") Date endTime);
}

